SELECT *, CASE WHEN `name` LIKE "new york city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "new york city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "new york city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "new york city" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("new york city") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$2,250,000500 Grand St Unit A9B9New York City NY 10002View Listing
$2,185,000477 Fdr Dr Unit M103-4 -5New York City NY 10002View Listing
$1,995,000453 Fdr Dr Unit C803-804New York City NY 10002View Listing
$1,950,000475 Fdr Dr Units L405 & 406New York City NY 10002View Listing
$1,595,000385 Grand St Apt L301New York City NY 10002View Listing
$1,398,000530 Grand St Unit D4C4New York City NY 10002View Listing
$1,375,000266 E Broadway Apt B706New York City NY 10002View Listing
$1,234,000477 Fdr Dr Unit M1802-1803New York City NY 10002View Listing
$1,195,000212 E Broadway Apt G1406New York City NY 10002View Listing
$1,095,000208 E Broadway Apt J706New York City NY 10002View Listing
$1,050,000575 Grand St Apt E105New York City NY 10002View Listing
$999,000208 E Broadway Apt J1803New York City NY 10002View Listing
$935,000264 E Broadway Apt C2003New York City NY 10002View Listing
$925,00077 Fulton St Apt 11KNew York City NY 10038View Listing
$850,000577 Grand St Apt F804New York City NY 10002View Listing
$845,000575 Grand St Apt E1402New York City NY 10002View Listing
$815,000500 Grand St Unit A11ENew York City NY 10002View Listing
$785,000415 Grand St Apt E1407New York City NY 10002View Listing
$775,000575 Grand St Apt E702New York City NY 10002View Listing
$775,000453 Fdr Dr Apt C205New York City NY 10002View Listing
$715,000415 Grand St Apt E1805New York City NY 10002View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 2:02:51 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Ranch
Single Family
